EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'Auto_download_movie_db'
GO
USE [master]
GO
ALTER DATABASE [Auto_download_movie_db] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
USE [master]
GO
DROP DATABASE [Auto_download_movie_db]
GO

USE Master
GO
CREATE DATABASE [Auto_download_movie_db]
GO
USE [Auto_download_movie_db]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[M_Keyword]') AND type in (N'U'))
    DROP TABLE [dbo].[M_Keyword]
GO
CREATE TABLE [dbo].[M_Keyword] (
[m_keyword_id] int  NOT NULL  
, [m_keyword_string] char(200)  NULL  
, [m_keyword_insert_timestamp] datetime  NULL  
)
GO

ALTER TABLE [dbo].[M_Keyword] ADD CONSTRAINT [M_Keyword_PK] PRIMARY KEY CLUSTERED (
[m_keyword_id]
)
GO
GO

GO

